home *** CD-ROM | disk | FTP | other *** search
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- ::::::::::::::: ::::::::::::: ::::::::::::::
- :::::::::::::::: ::::::::::::::: ::::::::::::::::
- ::::: ::::: ::::: ::::: ::::: ::::::
- ::::: ::::: ::::: ::::: ::::: :::::
- :::::::::::::::: ::::::::::::::::: ::::: :::::
- ::::::::::::::: ::::::::::::::::: ::::: :::::
- ::::: ::::: ::::: ::::: ::::: :::::
- ::::: ::::: ::::: ::::: ::::: ::::::
- ::::: ::::: ::::: ::::: ::::::::::::::::
- ::::: ::::: ::::: ::::: :::::::::::::: Plus
-
-
- Remote Access Database v2.00
-
- (dBASE III & dBASE III Plus Compatible)
-
- Copyright (C) 1990 Overerx Inc.
- Box 323 Sta A, Kingston, Ontario, Canada K7M 6R2
- Harvey Parisien * FidoNet 1:249/114
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- RAD Plus - Remote Access Database
-
-
-
-
-
-
-
-
-
-
-
-
- Background / What is RAD?
-
-
-
- RAD v1.?? has been around for a while now. It is a simple
- online database system with it's own dedicated file
- structure. It is simple to operate, and serves a purpose.
- Primarily it is directed towards BBS use. It is available on
- a shareware basis and distributed via SDS (Software
- Distribution System).
-
- RAD Plus v2.?? is the commercial version which is in dBASE
- III format file structure for optimum flexibility and
- compatibility with current and future environments. It tends
- to simulate standard dBASE<tm> type commands, which are
- familiar to dBASE users. It is also offered on a shareware
- basis and distributed via SDS.
-
- This document will deal only with RAD Plus, but will simply
- make reference to the name RAD to save key strokes.
-
- We will refer to the RAD Operator, and the RAD User. The RAD
- Operator is the System Operator (SysOp) or the System
- Administrator whatever the case may be. The RAD User is the
- remote caller.
-
- RAD is designed with many considerations to offer maximum
- security to the BBS SysOp, and in non-bbs (less secure)
- environments. However, the concern for security does not
- make remote maintenance difficult for the RAD Operator. All
- maintenance can be performed remotely with the correct
- security level. For non-bbs type setups, you may request
- from the author a Host/Terminal system which will allow
- control of your computer remotely (including file transfers),
- and can be used to answer the phone for RAD, clear passwords,
- and so on (it will create a dorinfo1.def exit file - more on
- that later). HTERM is a nice terminal for the remote user as
- well, written by the author of RAD. It is available as
- freeware on most BBS systems, or request HTERM.LZH from the
- FidoNet address stated below.
-
-
-
-
-
-
-
-
-
- Page 1
-
-
-
- RAD Plus - Remote Access Database
-
-
- Files required to setup RAD...
-
- RAD comes in an archived format. We use LHARC as our standard, but some BBS's
- or distribution systems may convert the archive structure. The archive name is
- usually RAD???.LZH where ??? is the version number. IE: RAD201.LZH is the
- archive for version 2.01.
-
- The files in RAD???.LZH are:
-
- DB.EXE A dBASE III file editor (used for setup).
- DB.DOC Documentation for above.
- * RADPLUS.EXE RAD the program.
- RADPLUS.DOC This document.
- * RADCFG.DBF RAD's main configuration file.
- * RADDIR.DBF RAD's file directory/file subject file.
-
- * = required for RAD to operate.
-
- ARTICLES DBF Sample database...
- BOOKS DBF Sample database...
- PHONEMSG DBF Sample database...
- SERVICES DBF Sample database...
- SUPPORT DBF Sample database...
- TTD DBF Sample database...
-
- FREE.TXT Some general information text files...
- INFO.TXT Some general information text files...
- RAD200.SDA Some general information text files...
- HTERM.DOC The documentation file that comes with hterm for your interest.
-
- REGISTER.TXT An application for to register RAD.
-
- DORINFO1 DEF Sample exit file (created by BBS or other answering devices)
-
- The only files required to run RAD are the ones marked with a *. Your security
- levels and modem information etc. are contained in RADCFG.DBF and RADDIR.DBF.
- Let's look at each file and discuss them in detail. Use DB.EXE to edit both
- RADDIR.DBF and RADCFG.DBF for your initial setup.
-
-
- RADCFG.DBF
-
- Record: 1 of 1
-
- SYSOP_NAME :Harvey Parisien :
- SYSTEMNAME :The Lighthouse BBS :
- KEY :0000000000000000000000000000:
- LEVEL1 : 5:
- LEVEL2 : 20:
- LEVEL3 : 40:
- LEVEL4 : 100:
- USAGE_LOG : :
- DOOR_INFO :dorinfo1.def :
- MIN_TIME : 5:
- MAX_TIME : 120:
- COM_PORT :COM1:
- MAX_BAUD :2400 :
- USE_SCREEN :T:
-
- Page 2
-
-
-
- RAD Plus - Remote Access Database
-
-
-
- SYSOP_NAME is the name of the System Operator (can be a department or company
- name also), and SYSTEMNAME is the BBS name (can be just an internal system name
- of any sort). The KEY field must contain the key you receive when you register
- RAD Plus. When you have the key entered, it will not bother reminding you to
- register any more.
-
- Level1 through to level4 are basically translation tables to translate your
- numeric security levels from your BBS, to RAD's 4 basic user levels. In the
- scenario above, in order to have level 3 access, your BBS access level must be
- at least 40 or greater.
-
- If you would like RAD to keep a usage log for you, enter a complete drive spec
- and path for your log file. The log will record logons, and database changes,
- and each applicable record number. Here's an example...
-
- 11/04/90 15:46:32 Logged ON ******** `JASON MURDUCK'
- 11/04/90 15:46:50 File write: SUPPORT.DBF 3
- 11/04/90 15:46:54 SysOp chat...
- 11/04/90 15:50:30 ...chat over.
- 11/04/90 15:50:32 Logged OFF ********
-
- DORINFO1.DEF is a standard exit control file produced by QuickBBS and other
- popular BBS systems, containing the current users information. As your BBS
- system exits to operate an external program like RAD, it writes this little
- file to allow the external program to read it and have the current transfer
- information. Take a look at the file description that follows for the type of
- information it contains. If you describe dorinfo1.def complete with drive spec
- and path, it will be used to decide whether the user can support ANSI/Color, how
- much time he/she has left online, current access level, etc...
-
- If you do not have a parent system that creates DORINFO1.DEF, let us know and
- we'll try to accommodate. Most BBS systems produce exit control files of one
- type or another, and there are many little conversion programs available on
- BBS's that will convert from one to another. In that case you would have to run
- RADPLUS from a batch file. For example
-
- Sample batch for systems that don't produce dorinfo1.def
-
- WINGWANG ... THE BBS SYSTEM
- CONVERT ... THE CONVERTER (changes wingwang.xit to dorinfo1.def)
- RADPLUS ... RADPLUS
-
- Sample dorinfo1.def...
-
- The Lighthouse BBS ;Systems name
- HARVEY ;SysOps first name
- PARISIEN ;SysOps last name
- COM1 ;Current port
- 2400 BAUD,N,8,1 ;Current connection information
- 0
- JOHN ;User's first name
- SMITH ;User's last name
- KINGSTON, ON ;User's address
- 1 ;ANSI on/off flag
- 20 ;User's SECURITY LEVEL
- 59 ;User's MAX TIME ALLOWED (balance of time from recent
- BBS activities)
-
- Page 3
-
-
-
- RAD Plus - Remote Access Database
-
-
-
- The next fields MIN_TIME and MAX_TIME are online time limits, and are in
- minutes. If you enter information here, it overrides dorinfo1.def (can be used
- for systems that don't produce dorinfo1.def to limit access time). IE, if your
- user has 90 minutes left online and your MAX_TIME is set to 10, then he/she will
- have 10 minutes in RAD only. It is recommended that you set MIN_TIME to 0 if it
- is your intention to NOT allow further access once a users time has run out.
-
- Your COM_PORT must be described as COM1, COM2, COM3, or COM4.
-
- Your MAX_BAUD can range from 300 baud to 115200 baud.
-
- The USE_SCREEN field is a logical setting of T or F (true or false). If you set
- this to F then the screen will remain BLANK during RAD operations. This may be
- desirable for multitasking situations. Normally this would be T. It is
- possible for the SysOp while the user is online to turn the screen ON or OFF by
- pressing F2 (snoop) on the HOST system. It is also possible for a user with the
- maximum level 4 setting to turn the screen on or off remotely.
-
- RADDIR.CFG
-
-
- Record: 1 of 8
-
- FILE :RADCFG.DBF :
- SUBJECT :RAD Main Configuration File :
- DISPLAY_ON :T:
- USER_NOTES :SYSOP :
- DISPLAY1 :Keep this file marked private :
- DISPLAY2 : :
- DISPLAY3 :This file contains your setup and default information. :
- DISPLAY4 : :
- DISPLAY5 :Use DB3ED (DB.EXE) or RAD to edit this file. :
- DISPLAY6 : :
- DISPLAY7 :NOTE: Leave the field DOOR_PATH blank if you will be :
- DISPLAY8 : using RAD offline only! :
- PASSWORD :YOURPASSWORD :
- MIN_LEVEL :4:
-
- This database file contains the FILE name and SUBJECT line for each file that is
- to be displayed by a DIR command online. If a *.dbf file exists and is not
- recorded in the RADDIR file, it will show up in a DIR, but will have a ? for
- subject line and have no password or minimum level access requirement. The
- third field DISPLAY_ON can be set to T or F. It determines whether the Display1
- through to Display8 fields are displayed when the file is accessed with a DIR
- command. Display1 to Display8 are not displayed when the file is accesed using
- a USE command. See the next few screens which simulate the DIR and file
- selection screens. USER_NOTES can be anything you like. The person who lists
- the file usually puts his/her John/Martha Henry here, and grocery list or
- whatever else comes to mind. PASSWORD is your 16 character password required
- for this file. You don't need a password for the MIN_LEVEL system to work. The
- MIN_LEVEL is an absolute minimum access level required to even have the ability
- to enter a password. The TWO levels of security for each database file should
- cover most situations. MAKE SURE YOUR RADCFG.DBF AND RADDIR.DBF FILES ARE BOTH
- PASSWORDED AND SET TO 4 AS THE MIN_LEVEL. If you do not want to allow online
- editing of these two files by a remote SysOp, then set the MIN_LEVEL to 5 so it
- can't be accessed at all.
-
-
- Page 4
-
-
-
- RAD Plus - Remote Access Database
-
-
- Here is a DIR simulation from the dot prompt...
-
- .dir
-
- RAD v2.01 - Remote Access Database - Copyright (C) 1990 Overerx Inc.
-
- # Filename Records Updated Subject
- 1 BBSLIST.DBF 1280 11/04/90 A list of BBS's with >= 100megs online
- 2 DB.DBF 3 11/04/90 A list of contacts for local services...
- 3 IDEAS.DBF 1 11/04/90 Ideas for RAD databases ...
- 4 SUPPORT.DBF 68 11/04/90 Computer related product support lines
-
- Enter # _
-
- NOTE: RADCFG.DBF and RADDIR.DBF will not be displayed in a Directory.
-
- When you enter RAD, you are presented with a pretty nifty title page (free ad
- for me), and then displayed your current stats like the following session
- simulation. We enter the HELP command which shows a command summary...
-
- 11/05/90 9:48a
-
- Registered to.......... The Lighthouse BBS
- System Operator........ Harvey Parisien
- User................... HARVEY PARISIEN
- User level............ 4
- Balance online time... 19 minutes
-
- Hello HARVEY ...
-
- (Enter HELP for commands)
- .help
-
- Command: Function: Level:
- HELP (or ?) Display this screen (/=Quick Help Screen) 1
- INFO Display system and user information 1
- CLS Clears Screen and Resets FIND search to ALL 1
- COLOR Toggles Ansi Color ON/OFF 1
- DIR Displays directory of *.DBF files 1
- USE filename.dbf USE or LOAD database (.dbf not required) 1
- LIST STRUCTURE List the file structure for the current database 1
- FIND text FIND and display record matching text 1
- BROWSE text FIND and list records (max fields that fit on one line) 1
- NEXT FIND and display NEXT record (or just press ENTER) 1
- GOTO n where n is the record number (also GOTO FIRST or LAST) 1
- COUNT FIND and COUNT occurrences of FIND 1
- SUM fieldnumber Add contents of a field and display total 1
- ADD ADD (or append) a new record 2
- EDIT n n is an optional record number (default = current record) 2
- DELETE n n is an optional record number (default = current record) 2
- CREATE Closes current file, and prompts for creation details 3
- PACK Pack current database (removes deleted files) 3
- SORT fieldnumber SORT database on a field (will prompt for fieldnumber) 3
- QUIT Exit program (closes all files)
- .
-
-
-
-
- Page 5
-
-
-
- RAD Plus - Remote Access Database
-
-
- You can also ask for a Quick Help Screen which is a brief summary of the above
- command list...
-
- ./
- HELP ? or / INFO CLS DIR USE LIST S FIND
- BROWSE NEXT GOTO COUNT SUM ADD EDIT DELETE
- CREATE PACK SORT SCREEN QUIT
-
- The online commands will be very intuitive to dBASE users and non dBASE users
- alike. The screens and prompts should provide adequate information for the
- typical user online.
-
- SYSOP FUNCTIONS
-
- USER: Joe Blow PARAM: COM1:2400,N,8,1,RB1024,XON LEVEL: 3
- 1 CHAT |2 SNOOP|3 |4 |5 |6 JUMP |7 |8 |9 LEVEL|10 HANG
-
- The last two lines on your HOST screen remain in position at all times. They
- constantly display the Users name, and current communications data. It shows
- the users level which can be toggled with F9. OK, let's continue from right to
- left just to be different. F10 causes an immediate hang up to which the user is
- given no indication or warning as to what happened. F6 allows the host to jump
- to DOS. F2 allows the HOST to toggle the HOST screen on/off. F1 allows the
- host to enter into CHAT mode, where both host and user can chat to each other
- with their keyboards. By the way, when a users time online gets to be 2 minutes
- or less, he/she is given a warning to that effect (even if in chat mode). They
- can always enter INFO to see their current status.
-
-
- Operating RAD Plus from the command line, or a parent program.
-
- RADPLUS /Pdrive:fullpath
-
- IE: from a DOS prompt... D:\>c:\dbase\radplus /Pc:\dbase
-
- drive:path is where RADPLUS.EXE RADDIR.DBF RADCFG.DIR AND *.DBF files are kept.
-
- If no path is given the current directory is assumed.
-
- IE: QuickBBS type 7 command line: c:\rad\radplus.exe /Pc:\rad
-
- It is important that if /P is used, that the path is complete with drive spec
- as in these examples.
-
- If you are operating RAD locally (ie from your BBS in local mode) it will
- sense there is no carrier so it requires you to press L to enter locally or
- it exits back to the board automatically. RAD has a built in carrier detect
- system. If carrier is dropped while a user is in RAD (or on their way to rad),
- it gracefully exits back to your board and let's your board do it's own thing.
-
- Please feel free to contact me in the SHAREWARE echo of FidoNet. If you are a
- registered user (or planning to be if RAD suits your purpose), feel free to
- NETMAIL anytime for instant support.
-
- Harvey Parisien, FidoNet 1:249/114
- Box 323 Sta A, Kingston, Ontario, Canada K7M 6R2
- 613-389-3992 BBS
-
-
- Page 6
-
-
-
- RAD Plus - Remote Access Database
-
-
-
- This program is shareware. It may be used for a 20 day trial period, and then
- must be registered.
-
-
-
- REGISTRATION
-
-
- RADCFG requires a unique KEY to be entered in the key field. By providing us
- with your SYSOP_NAME and SYSTEMNAME field information from RADCFG, we can create
- the key. Once you enter the key, you can't change SYSOP_NAME or SYSTEMNAME
- afterwards, or the key will not work. This is our only protection. There are
- not timers, or other sneaky methods implemented in your program. RAD is fully
- functional. To register, please fill out the REGISTER.TXT application. You can
- load it into your word processor and edit it, or copy it to your printer and do
- it by hand (COPY REGISTER.TXT PRN). Send it to Overerx Inc. (address is
- contained in register.txt and also above). (I would prefer that you also
- enclose a simple screen dump of your RADCFG file showing me the exact SYSOP_NAME
- and SYSTEMNAME entries for key creation)
-
- When you receive your REGISTRATION KEY, enter it in the KEY field of RADCFG.
- RAD will then be registered and legally yours. In addition, you will be able to
- use future updates of RAD Plus using the same REGISTRATION KEY. So when you
- register once, you never pay again.
-
-
- Registration is $65.00.
-
- Non Commercial BBS SysOps may register RAD Plus for $ 25.00.
-
-
- CUSTOM APPLICATIONS AVAILABLE !!!
-
-
-
-
- LEGAL STUFF
-
- DISCLAIMER - This program is provided as is. You may use it at your own risk.
- There is no warranty of any kind or any form covering this program. The author
- may in no way be held liable for any damage of any form in connection or arising
- from the quality and/or use of this program and any associated files included
- with it.
-
-
-
-
-
-
-
-
- ** YOUR FEEDBACK, AND SUPPORT IS APPRECIATED **
-
-
-
-
-
-
- Page 7
-
-
-